﻿CREATE TABLE [dbo].[ERP_DataChange] (
    [id]            INT           IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [Proposer]      NVARCHAR (50) NULL,
    [ProposerName]  NVARCHAR (50) NULL,
    [ProposeTitle]  INT           NULL,
    [PCompanyId]    INT           NULL,
    [PDepartmentId] INT           NULL,
    [ApplionTime]   DATETIME      NULL,
    [BDetails]      VARCHAR (MAX) NULL,
    [ADetails]      VARCHAR (MAX) NULL,
    [CAuditPerson]  NVARCHAR (50) NULL,
    [CAudit]        BIT           CONSTRAINT [DF_ERP_DataChange_CAudit] DEFAULT ((0)) NULL,
    [CMemo]         VARCHAR (MAX) NULL,
    [CAuditTime]    DATETIME      NULL,
    [FAuditPerson]  NVARCHAR (50) NULL,
    [FAudit]        BIT           CONSTRAINT [DF_ERP_DataChange_FAudit] DEFAULT ((0)) NULL,
    [FMemo]         VARCHAR (MAX) NULL,
    [FAuditTime]    DATETIME      NULL,
    [JEditPerson]   NVARCHAR (50) NULL,
    [JEdit]         BIT           CONSTRAINT [DF_ERP_DataChange_JEdit] DEFAULT ((0)) NULL,
    [JMemo]         VARCHAR (MAX) NULL,
    [JEditTime]     DATETIME      NULL,
    [State]         INT           NULL,
    CONSTRAINT [PK_ERP_DataChange] PRIMARY KEY CLUSTERED ([id] ASC)
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'申请人', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ERP_DataChange', @level2type = N'COLUMN', @level2name = N'Proposer';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'申请人姓名', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ERP_DataChange', @level2type = N'COLUMN', @level2name = N'ProposerName';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'申请人单位', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ERP_DataChange', @level2type = N'COLUMN', @level2name = N'PCompanyId';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'申请时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ERP_DataChange', @level2type = N'COLUMN', @level2name = N'ApplionTime';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'修改前内容（错误信息）', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ERP_DataChange', @level2type = N'COLUMN', @level2name = N'BDetails';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'修改后内容', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ERP_DataChange', @level2type = N'COLUMN', @level2name = N'ADetails';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'部门/公司负责人', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ERP_DataChange', @level2type = N'COLUMN', @level2name = N'CAuditPerson';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'部门/公司负责人审批结果', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ERP_DataChange', @level2type = N'COLUMN', @level2name = N'CAudit';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'部门/公司负责人批注', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ERP_DataChange', @level2type = N'COLUMN', @level2name = N'CMemo';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'部门/公司负责人审批时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ERP_DataChange', @level2type = N'COLUMN', @level2name = N'CAuditTime';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'财务负责人', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ERP_DataChange', @level2type = N'COLUMN', @level2name = N'FAuditPerson';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'财务负责人审批结果', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ERP_DataChange', @level2type = N'COLUMN', @level2name = N'FAudit';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'财务负责人审批批注', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ERP_DataChange', @level2type = N'COLUMN', @level2name = N'FMemo';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'财务负责人审批时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ERP_DataChange', @level2type = N'COLUMN', @level2name = N'FAuditTime';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ERP_DataChange', @level2type = N'COLUMN', @level2name = N'State';

